UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7EBYoSTTmpm5ZwNvz7PoGVWcAG231Q9Cq1FJx3tYXx4='
WHERE
key_id = '5b3de8a506e23f37e4302a727de6b3ec237f610551828e92be561575a3eaba06'
AND (
token = '7EBYoSTTmpm5ZwNvz7PoGVWcAG231Q9Cq1FJx3tYXx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)