UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ut7u7/14HmTZbVvz0Zmn+ldyJQuKKT4JJpOR12tY/rk='
WHERE
key_id = 'ac5f8c1015ab3ce636dff02a486143347786fadd3a31f13b851b2755f54d023e'
AND (
token = 'ut7u7/14HmTZbVvz0Zmn+ldyJQuKKT4JJpOR12tY/rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)