UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bL0tXqzPVa8FZJXms/OWS+PZo+Vk1Og6E2hw2zbTPwg='
WHERE
key_id = '6a49d69cd507d98a6abd86672159fcca8055cd4a16dfa211f48b8eb674b69a15'
AND (
token = 'bL0tXqzPVa8FZJXms/OWS+PZo+Vk1Og6E2hw2zbTPwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)