UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a1UDixbdvbR1SfznFWIbI3iuZ1WyusW98u6FNK04Zbg='
WHERE
key_id = '7c318bc9517f51a6698398e3f73008a9e201250ccc5dc042fab8e672fa728983'
AND (
token = 'a1UDixbdvbR1SfznFWIbI3iuZ1WyusW98u6FNK04Zbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)