UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u9lpMDxcraAiWhYwdYbwpWvm+AXGdYkjyB/+pEYItOg='
WHERE
key_id = 'bfacc317445d048c5e7516819c869582511c386d233d3c6707ab60d6ac798edf'
AND (
token = 'u9lpMDxcraAiWhYwdYbwpWvm+AXGdYkjyB/+pEYItOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)