UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hj0oHBLGxCdPGdSBGKZvrYV5PNAf7uDXpJYjRy2QXRg='
WHERE
key_id = 'd9584d77741d3789bc24e99b9ca998801a5db7d43edab10ccbf0f4b297158d6e'
AND (
token = 'Hj0oHBLGxCdPGdSBGKZvrYV5PNAf7uDXpJYjRy2QXRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)