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