UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sKrRtMBVAXOBLxr6lVmgYFLTr2FDWeRECG/rPu1lzdM='
WHERE
key_id = '94758a584029afac995e0f9b1a308bb9973fe81878623272bc17e93fedc13557'
AND (
token = 'sKrRtMBVAXOBLxr6lVmgYFLTr2FDWeRECG/rPu1lzdM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)