UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pSdZprUPaUFNX1yacgXG6izChdaQNfXO3DVYCfXYulM='
WHERE
key_id = '54a1f5e9500d4e1d8505c0fdedde4c2a306cc86840b0769a4fd70cfeae46c13b'
AND (
token = 'pSdZprUPaUFNX1yacgXG6izChdaQNfXO3DVYCfXYulM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)