UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nl7yip7QXiv2vm19XLLmiOxVEOJh0pi+U78MVxRLcUA='
WHERE
key_id = '1f2a176fa8c098cbbbf44378e1665bf5ec9acadf0e634451b9cd0aed8f2674ff'
AND (
token = 'nl7yip7QXiv2vm19XLLmiOxVEOJh0pi+U78MVxRLcUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)