UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pj/C19GqgJIT3FubWkCna9BL8G1YwFYku+hghBx8wb0='
WHERE
key_id = '07b99ffbd3ea1a37b7f2d7cacf3caf5966c2a915c508139caf944fe80c61a9f3'
AND (
token = 'pj/C19GqgJIT3FubWkCna9BL8G1YwFYku+hghBx8wb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)