UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pjAkwI3m1j1aBR42L/ElBWTWos4Uc8wqkkN0jiH8ww0='
WHERE
key_id = 'fe338497f6bb2d8051b06bd469403b233dfa64c399936a01d40e67167dbe9a9c'
AND (
token = 'pjAkwI3m1j1aBR42L/ElBWTWos4Uc8wqkkN0jiH8ww0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)