UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nWfoOUfjLXreKS6RLXZBQWvDKBR6MT4EoJnIxaXBpaM='
WHERE
key_id = '28e4a57a7630219bff2d672cf962bd6f1320365c0ec7049060f1e5bd9da4e886'
AND (
token = 'nWfoOUfjLXreKS6RLXZBQWvDKBR6MT4EoJnIxaXBpaM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)