UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'haXpRTuni7mrvcCDXjmLuoVqjJylrnerkx+6wgxv72w='
WHERE
key_id = '54d10e37e43a2f405475ca417dd98cd7a1e867f8471b52a5321fa25e70f1629e'
AND (
token = 'haXpRTuni7mrvcCDXjmLuoVqjJylrnerkx+6wgxv72w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)