UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VgkcxIVSZWSux8BlrajIhIx1khOtVcTUU3kyc2p4F1A='
WHERE
key_id = '8ead275b2447bbd3adc1f6898aae6eb8a0a391d5217731ea29832b5104c7ab89'
AND (
token = 'VgkcxIVSZWSux8BlrajIhIx1khOtVcTUU3kyc2p4F1A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)