UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oFCXiIZOJWOxxWnfbypr539XoYqGOo63pXPW/DnGUQQ='
WHERE
key_id = 'f7766ec37ea69ed02c84f3524f4b24c03ab4bf7cc712f965a38c9b30e4863450'
AND (
token = 'oFCXiIZOJWOxxWnfbypr539XoYqGOo63pXPW/DnGUQQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)