UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KYhIh2FJbrXw/0cl+7tt9mGTFor0T8960C8NMi8DVY4='
WHERE
key_id = 'a3694a0220334cd5707cf1b142a41b642bf0b5b172a2a27d1e058e1712565ea1'
AND (
token = 'KYhIh2FJbrXw/0cl+7tt9mGTFor0T8960C8NMi8DVY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)