UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L+KDouk6PSufFVX1w7Smea9HhKKWc20DzVgTn8nbpr8='
WHERE
key_id = 'd580b12e5cd41aea4852c35ae4b84f32d6a6933ae2e9379d42e8b87f75529c94'
AND (
token = 'L+KDouk6PSufFVX1w7Smea9HhKKWc20DzVgTn8nbpr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)