UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xBLOa1gX9zbghOQO/Ag1SF4L4IeJDHqx+M/n7hfCCtY='
WHERE
key_id = '7647ed5d1678797ba0191d6448795f7ddb75e09778af7426bc9b2aaea57dbd0e'
AND (
token = 'xBLOa1gX9zbghOQO/Ag1SF4L4IeJDHqx+M/n7hfCCtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)