UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'shK+5I5VVN2WeCRBuv8wJrfw4qNehkgiCZNP89kHwpg='
WHERE
key_id = 'b6ba2665148a7f8da58962a2096e27bcea5856947a76f7a178b7cf79e9c6d51a'
AND (
token = 'shK+5I5VVN2WeCRBuv8wJrfw4qNehkgiCZNP89kHwpg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)