UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kmS3Qx8E4s0IrjYo8Pk1avBVFkBPycbWAcd4rs6m/wA='
WHERE
key_id = '7a31419df567cb27b321086877937bf1a5efaf2bbb0242baf2baa625006e1ed0'
AND (
token = 'kmS3Qx8E4s0IrjYo8Pk1avBVFkBPycbWAcd4rs6m/wA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)