UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1wHJtcO4+4TFUynKVS0q7ol08G/nVssNO6Q+pnVKrZ4='
WHERE
key_id = '1bc29c4d5e34417782ccc87d38009a542bae0104f761df4741c966356730279b'
AND (
token = '1wHJtcO4+4TFUynKVS0q7ol08G/nVssNO6Q+pnVKrZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)