UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E4uGDoxjgQUjLk9E6niYFBXOwEYcClGZQxV00GQHDIE='
WHERE
key_id = 'c9c44050b670479f5cb3645e10f43de0a85368577e307bbc26cfa5d4bf5e71cd'
AND (
token = 'E4uGDoxjgQUjLk9E6niYFBXOwEYcClGZQxV00GQHDIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)