UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6BhgrZkm6707oanGzqexGUglNiBCeTRZHxB+oqoJ6Ok='
WHERE
key_id = 'd20119ab13d5240f160f7f5bc04ad2275076081bed4ad6440ea709c2f1154a02'
AND (
token = '6BhgrZkm6707oanGzqexGUglNiBCeTRZHxB+oqoJ6Ok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)