UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XFnIEJ7ytpgXNoiSVnGOX17ZSGhpQOnkeYnjanP2SFw='
WHERE
key_id = 'b7c070c960a2ab253c55e81350e115f0e5b657c01c66f1143ff420c4a987aefa'
AND (
token = 'XFnIEJ7ytpgXNoiSVnGOX17ZSGhpQOnkeYnjanP2SFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)