UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0pKi8U3KExV28UOOAFCyxOifF5RFZFPDYSLfYCMIizc='
WHERE
key_id = 'c7b2e5e65368baa0251fe40dcdd0ad0dfa4f59b8c38fddafcfba2af9e6d17d34'
AND (
token = '0pKi8U3KExV28UOOAFCyxOifF5RFZFPDYSLfYCMIizc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)