UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RrmNWETkZzK1Xl8LPbSchspuPj8Y60Z38OL5nItr/RI='
WHERE
key_id = '29d01a2f859f8d01c9745678dd9a9e167e67fef2fec6ef3958a99f13152531c4'
AND (
token = 'RrmNWETkZzK1Xl8LPbSchspuPj8Y60Z38OL5nItr/RI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)