UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4EDGxkJeWolL5DSIihtTVF4xw0oIbrasGUyyRJC8fAc='
WHERE
key_id = '1e83da9e5960ff35b5f31bc93014ddf21ecef8d6ba2bf83a73b5c2be02d69cda'
AND (
token = '4EDGxkJeWolL5DSIihtTVF4xw0oIbrasGUyyRJC8fAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)