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