UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3NsKXLRJJ3hie3sGSpiIfxVmS6nrRmtXMAtrXe8Kyqw='
WHERE
key_id = 'dd5113a9f4f7712554f51e673d7ec13214984a1a43570c4499cc05551068a0b9'
AND (
token = '3NsKXLRJJ3hie3sGSpiIfxVmS6nrRmtXMAtrXe8Kyqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)