UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pu8fo36RamwF3F2TwQgXZuhS0a06Ekd7xptb/Ueob3k='
WHERE
key_id = 'af6103e2484b6a6859e117f3ae3280f931fe7eeced82f0540d230d68398e3df4'
AND (
token = 'pu8fo36RamwF3F2TwQgXZuhS0a06Ekd7xptb/Ueob3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)