UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SmXpxlMSseBYU1LPoc4JhGQlE+58UvVDj0I5p3m2py4='
WHERE
key_id = 'e96b849658f17d69aaf99d31354803fb0db1880ee79af4fa9ce238d6898de6da'
AND (
token = 'SmXpxlMSseBYU1LPoc4JhGQlE+58UvVDj0I5p3m2py4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)