UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DmBM7uOiUQut05olXW7zkbLcuVo+7nIyv4nGy5Y33ow='
WHERE
key_id = 'b9efb2981956bc63fbcb44427a7b7a344bac93b9eb6e8b58e1f51d9613e712fc'
AND (
token = 'DmBM7uOiUQut05olXW7zkbLcuVo+7nIyv4nGy5Y33ow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)