UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TX2wzkr59jrxa/5/dKFRb37iiYq6jYhoBxGUHKoEgQY='
WHERE
key_id = '2e5f4314e2e21dcedae0c72a79df26aea685ee23a543ef650e33e093a528e94a'
AND (
token = 'TX2wzkr59jrxa/5/dKFRb37iiYq6jYhoBxGUHKoEgQY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)