UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BHf4+pDGt4WcXoyUvIf4qIQFGhpJN5k5gL9sMBBWyvw='
WHERE
key_id = 'd027f5cc3cf3bab8c898cbf66a69a070e4375e00e66752e53f7e7fda907ff7cd'
AND (
token = 'BHf4+pDGt4WcXoyUvIf4qIQFGhpJN5k5gL9sMBBWyvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)