UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x7GUbCTuxYmAi4Q7ku6lwhnBl1JKL4zVlytg2XB1L2c='
WHERE
key_id = '2504923bc544fde804468359cd31f1974fbb9f0856cdbf5213680c934cd90a73'
AND (
token = 'x7GUbCTuxYmAi4Q7ku6lwhnBl1JKL4zVlytg2XB1L2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)