UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4HAH8wGe9eNh27jJYxBiOlgjekPujznANKaJphXpWB8='
WHERE
key_id = '6bc48d61605dce01df8ff4fd5e0deb9418b71af41dee13e54be400abb51590a4'
AND (
token = '4HAH8wGe9eNh27jJYxBiOlgjekPujznANKaJphXpWB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)