UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8YKHnHs05wM3r8Y9scnPo0J0zScWlUXLQeY4yR1aQv0='
WHERE
key_id = 'ae4f3ca69ba2f20c782fbf672ee60b79840d6163400ecaee8402c1a69d0ed139'
AND (
token = '8YKHnHs05wM3r8Y9scnPo0J0zScWlUXLQeY4yR1aQv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)