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