UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'boUsZaWrI1mH/PpBCSHdDVO58/L8VGD4JXU2gAzZKfw='
WHERE
key_id = '487958e6d80aebb203d34b33833a6646b37b0195b4de85ead979ba769c2b5cf7'
AND (
token = 'boUsZaWrI1mH/PpBCSHdDVO58/L8VGD4JXU2gAzZKfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)