UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pemBH28bKA42WA51JleH8owHMIh0SkxQC01Q0LZbq6Q='
WHERE
key_id = '788020955988e9f21e35306f53fc344804104a91abe4ab2225c7fe572c0b57cf'
AND (
token = 'pemBH28bKA42WA51JleH8owHMIh0SkxQC01Q0LZbq6Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)