UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w6weRMNzsRkOdApIdumCsKjJte0U3nN+2I98haADckI='
WHERE
key_id = '7f7f041a995322bdae8cbdea0d09cda574a741faf9bf75b83755e9b2fc4e19c8'
AND (
token = 'w6weRMNzsRkOdApIdumCsKjJte0U3nN+2I98haADckI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)