UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yR1G7Ji8hNssYTcExWWDvWNpoXT6InXJHBj4vzvPsnA='
WHERE
key_id = '534b45c1e71f446567453c9254a0b29872c5b72bca1a5f07f40ff8a8fdfc4ca7'
AND (
token = 'yR1G7Ji8hNssYTcExWWDvWNpoXT6InXJHBj4vzvPsnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)