UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xhkgak+kpItHcZmov9i9KcokgyOAlvVcIK8cowUiQQs='
WHERE
key_id = '559d3e70d1cf08de10b63b9a0713ea13b574c61b5a405e99f9699914135fb471'
AND (
token = 'xhkgak+kpItHcZmov9i9KcokgyOAlvVcIK8cowUiQQs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)