UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wjSKj0vzhDw1rHSdQ+zpc+7xWh2aICi+LNTqBYJlX14='
WHERE
key_id = 'b234df12e13d631df7fea16bc3f2927c0bf93e10d5fc2939567e6d34d6ad39e1'
AND (
token = 'wjSKj0vzhDw1rHSdQ+zpc+7xWh2aICi+LNTqBYJlX14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)