UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5CREhz2fKoKhZ64zXG25URozarEtCdxcec46Dg29Vyw='
WHERE
key_id = 'aefd559c24d7930f43a03efcf03ab1e91bcbe3c981e834b99f96409ffc169cdc'
AND (
token = '5CREhz2fKoKhZ64zXG25URozarEtCdxcec46Dg29Vyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)