UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZPXPI5ApVNXtzfrvH4eLZOvQ/j32f0h6Ql2/CLro1Do='
WHERE
key_id = '4e1aea0d38abffbeb36f5f2fe2593c7dc74017a6707cfcb4374ea254ee716e9b'
AND (
token = 'ZPXPI5ApVNXtzfrvH4eLZOvQ/j32f0h6Ql2/CLro1Do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)