UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DYv88xCPioRN+paPFPWsuTjYajG6+c2gCnSHL1FlFXs='
WHERE
key_id = '4db67144eb5a2ae3860a0d2ee44f109795bc5c27b9dfb3fbe39e8e23b2b6dd1a'
AND (
token = 'DYv88xCPioRN+paPFPWsuTjYajG6+c2gCnSHL1FlFXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)