UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nvzx9KLz1zXk5wHJgTzuUp/g8irbrE7cN1z2Hs3hetI='
WHERE
key_id = '2def9c7c5b03ea74d8fc065d9eda528f2103f62e415942639037010b9e32bd9b'
AND (
token = 'Nvzx9KLz1zXk5wHJgTzuUp/g8irbrE7cN1z2Hs3hetI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)