UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oaG2wvzdAlNnP+RlM18ccSB3qnN73kw2KM5xiN9Qn58='
WHERE
key_id = 'ae16e6f7f2f3428a34c607022a3aad838997ed93ac9f27f196fad77e7930a6a0'
AND (
token = 'oaG2wvzdAlNnP+RlM18ccSB3qnN73kw2KM5xiN9Qn58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)