UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '86DjxaG0HRGaLQ8npW2sMUEeiz+19v8QJ3/R70Hw7Nk='
WHERE
key_id = '7af8391fd38301cb1e582a30763784b4543f61e1823384bf1afa5e2cd1894ce1'
AND (
token = '86DjxaG0HRGaLQ8npW2sMUEeiz+19v8QJ3/R70Hw7Nk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)