UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3aW6ZwcCKqpOhynGppa6eTT0x6qPiQhb+//gM6ui1mg='
WHERE
key_id = '5292a6874adf0c97a46a54286f0f362b5700dedbe9b17029d939a98acbf2eadd'
AND (
token = '3aW6ZwcCKqpOhynGppa6eTT0x6qPiQhb+//gM6ui1mg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)