UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lomo1ADiKJXvDgHfajg2LvT0dgeuvycyIHHnXyrxjnw='
WHERE
key_id = '6b48adff0cc5aa7e7b70d6148e414b617c4520e2954312fea5e0749d8d9ac6f5'
AND (
token = 'lomo1ADiKJXvDgHfajg2LvT0dgeuvycyIHHnXyrxjnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)