UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P/kGSg0GHOMG+bAajFQg4QyBGJTQRdHL46kC9gQxFS4='
WHERE
key_id = 'c1f22c5123abe8747b0ec482a3028b578394368c7b109d85e9ac409844bb6ad3'
AND (
token = 'P/kGSg0GHOMG+bAajFQg4QyBGJTQRdHL46kC9gQxFS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)