UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N7lFNodh0lH9oUcc/n47nWadZPDcDRne+q2MpkLVBcA='
WHERE
key_id = '95dbb02107ed6b0c456bd16e454c575f32b1af192b1d8dd19633edd991b5e88c'
AND (
token = 'N7lFNodh0lH9oUcc/n47nWadZPDcDRne+q2MpkLVBcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)